//
//  CurrencyExchangeType.h
//  MarketDataColloctor
//
//  Created by jiro on 10/03/11.
//  Copyright 2010 jiro music. All rights reserved.
//

#import <Cocoa/Cocoa.h>
#import "DbTableEntry.h"

class CurrencyExchangeType : public DbTableEntry
{
public:

	static NSString* tableName();
	static NSString* queryCreateTable();
	static NSString* queryFieldsOfCreateTable();
	static NSString* querySelectAll( const std::vector< ClauseNode >& clauses );
	static NSString* querySelect( const std::vector< FieldNode >& fieldNodes, const std::vector< ClauseNode >& clauses );
	static NSString* queryInsertInitialValues();
	
	CurrencyExchangeType();
	CurrencyExchangeType( std::vector< const char* > values );
	NSString* sqlInsertStatement() const;

	NSString* queryInsertValue() const;
	NSString* queryInsert() const;

	NSString* toString() const;

private:

	NSString* code;

	NSString* targetCurrencyCode;

};
